Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 3000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 211.1 KiB |
| Average record size in memory | 72.0 B |
Variable types
| Numeric | 9 |
|---|
Sensor_beta is highly correlated with Sensor_alpha_plus | High correlation |
Sensor_alpha_plus is highly correlated with Sensor_beta | High correlation |
Sensor_beta is highly correlated with Sensor_alpha_plus | High correlation |
Sensor_alpha_plus is highly correlated with Sensor_beta | High correlation |
Sensor_gamma is highly correlated with Sensor_alpha_plus | High correlation |
Sensor_alpha_plus is highly correlated with Sensor_gamma | High correlation |
df_index is uniformly distributed | Uniform |
df_index has unique values | Unique |
Sensor_alpha has unique values | Unique |
Sensor_beta has unique values | Unique |
Sensor_gamma has unique values | Unique |
Sensor_alpha_plus has unique values | Unique |
Sensor_beta_plus has unique values | Unique |
Sensor_gamma_plus has unique values | Unique |
Minutes has 42 (1.4%) zeros | Zeros |
Reproduction
| Analysis started | 2022-05-10 14:59:35.244873 |
|---|---|
| Analysis finished | 2022-05-10 14:59:56.223258 |
| Duration | 20.98 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8499.5 |
| Minimum | 7000 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 7000 |
|---|---|
| 5-th percentile | 7149.95 |
| Q1 | 7749.75 |
| median | 8499.5 |
| Q3 | 9249.25 |
| 95-th percentile | 9849.05 |
| Maximum | 9999 |
| Range | 2999 |
| Interquartile range (IQR) | 1499.5 |
Descriptive statistics
| Standard deviation | 866.1697293 |
|---|---|
| Coefficient of variation (CV) | 0.1019083157 |
| Kurtosis | -1.2 |
| Mean | 8499.5 |
| Median Absolute Deviation (MAD) | 750 |
| Skewness | 0 |
| Sum | 25498500 |
| Variance | 750250 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7000 | 1 | < 0.1% |
| 9003 | 1 | < 0.1% |
| 8994 | 1 | < 0.1% |
| 8995 | 1 | < 0.1% |
| 8996 | 1 | < 0.1% |
| 8997 | 1 | < 0.1% |
| 8998 | 1 | < 0.1% |
| 8999 | 1 | < 0.1% |
| 9000 | 1 | < 0.1% |
| 9001 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| 7000 | 1 | |
| 7001 | 1 | |
| 7002 | 1 | |
| 7003 | 1 | |
| 7004 | 1 | |
| 7005 | 1 | |
| 7006 | 1 | |
| 7007 | 1 | |
| 7008 | 1 | |
| 7009 | 1 |
| Value | Count | Frequency (%) |
| 9999 | 1 | |
| 9998 | 1 | |
| 9997 | 1 | |
| 9996 | 1 | |
| 9995 | 1 | |
| 9994 | 1 | |
| 9993 | 1 | |
| 9992 | 1 | |
| 9991 | 1 | |
| 9990 | 1 |
Hour
Real number (ℝ≥0)
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.59233333 |
| Minimum | 1 |
|---|---|
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 19 |
| median | 21 |
| Q3 | 21 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 22 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.507169985 |
|---|---|
| Coefficient of variation (CV) | 0.179007264 |
| Kurtosis | 11.89399048 |
| Mean | 19.59233333 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -3.333721061 |
| Sum | 58777 |
| Variance | 12.3002413 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) |
| 21 | 1440 | |
| 19 | 331 | 11.0% |
| 18 | 324 | 10.8% |
| 20 | 322 | 10.7% |
| 22 | 304 | 10.1% |
| 23 | 56 | 1.9% |
| 7 | 20 | 0.7% |
| 16 | 18 | 0.6% |
| 3 | 17 | 0.6% |
| 8 | 15 | 0.5% |
| Other values (13) | 153 | 5.1% |
| Value | Count | Frequency (%) |
| 1 | 15 | |
| 2 | 9 | |
| 3 | 17 | |
| 4 | 11 | |
| 5 | 11 | |
| 6 | 14 | |
| 7 | 20 | |
| 8 | 15 | |
| 9 | 11 | |
| 10 | 14 |
| Value | Count | Frequency (%) |
| 23 | 56 | 1.9% |
| 22 | 304 | 10.1% |
| 21 | 1440 | |
| 20 | 322 | 10.7% |
| 19 | 331 | 11.0% |
| 18 | 324 | 10.8% |
| 17 | 12 | 0.4% |
| 16 | 18 | 0.6% |
| 15 | 14 | 0.5% |
| 14 | 11 | 0.4% |
| Distinct | 60 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.79466667 |
| Minimum | 0 |
|---|---|
| Maximum | 59 |
| Zeros | 42 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 14 |
| median | 29 |
| Q3 | 44 |
| 95-th percentile | 56 |
| Maximum | 59 |
| Range | 59 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 17.18474935 |
|---|---|
| Coefficient of variation (CV) | 0.5968032047 |
| Kurtosis | -1.180180663 |
| Mean | 28.79466667 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0.03956982245 |
| Sum | 86384 |
| Variance | 295.3156101 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31 | 69 | 2.3% |
| 1 | 69 | 2.3% |
| 45 | 68 | 2.3% |
| 20 | 66 | 2.2% |
| 41 | 64 | 2.1% |
| 49 | 64 | 2.1% |
| 25 | 60 | 2.0% |
| 14 | 59 | 2.0% |
| 6 | 58 | 1.9% |
| 2 | 58 | 1.9% |
| Other values (50) | 2365 |
| Value | Count | Frequency (%) |
| 0 | 42 | |
| 1 | 69 | |
| 2 | 58 | |
| 3 | 52 | |
| 4 | 49 | |
| 5 | 45 | |
| 6 | 58 | |
| 7 | 53 | |
| 8 | 48 | |
| 9 | 48 |
| Value | Count | Frequency (%) |
| 59 | 47 | |
| 58 | 41 | |
| 57 | 51 | |
| 56 | 34 | |
| 55 | 47 | |
| 54 | 49 | |
| 53 | 46 | |
| 52 | 41 | |
| 51 | 50 | |
| 50 | 42 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.919117979 |
| Minimum | -342.2263886 |
|---|---|
| Maximum | 361.7641601 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1518 |
| Negative (%) | 50.6% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -342.2263886 |
|---|---|
| 5-th percentile | -165.7459598 |
| Q1 | -68.7988094 |
| median | -2.059706876 |
| Q3 | 65.06219685 |
| 95-th percentile | 161.5591035 |
| Maximum | 361.7641601 |
| Range | 703.9905488 |
| Interquartile range (IQR) | 133.8610063 |
Descriptive statistics
| Standard deviation | 99.17117412 |
|---|---|
| Coefficient of variation (CV) | -51.67539214 |
| Kurtosis | -0.0689697149 |
| Mean | -1.919117979 |
| Median Absolute Deviation (MAD) | 66.88891535 |
| Skewness | 0.03367334274 |
| Sum | -5757.353936 |
| Variance | 9834.921777 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -72.08358487 | 1 | < 0.1% |
| 91.39448163 | 1 | < 0.1% |
| 79.28848892 | 1 | < 0.1% |
| 21.90722291 | 1 | < 0.1% |
| 154.1833752 | 1 | < 0.1% |
| 186.4461613 | 1 | < 0.1% |
| -108.5311891 | 1 | < 0.1% |
| 10.20287818 | 1 | < 0.1% |
| -175.0275505 | 1 | < 0.1% |
| -48.36483576 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -342.2263886 | 1 | |
| -311.6466776 | 1 | |
| -299.8953994 | 1 | |
| -291.1066077 | 1 | |
| -275.609927 | 1 | |
| -275.5279953 | 1 | |
| -272.0506763 | 1 | |
| -271.8356354 | 1 | |
| -267.1534053 | 1 | |
| -266.0355009 | 1 |
| Value | Count | Frequency (%) |
| 361.7641601 | 1 | |
| 320.2013807 | 1 | |
| 314.2977292 | 1 | |
| 302.1744108 | 1 | |
| 298.2453478 | 1 | |
| 287.1738876 | 1 | |
| 284.7443466 | 1 | |
| 281.3691748 | 1 | |
| 278.4804936 | 1 | |
| 275.4192835 | 1 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -24.59531615 |
| Minimum | -612.7569858 |
|---|---|
| Maximum | 430.2453697 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1763 |
| Negative (%) | 58.8% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -612.7569858 |
|---|---|
| 5-th percentile | -232.6568962 |
| Q1 | -115.504386 |
| median | -31.30472733 |
| Q3 | 64.7707356 |
| 95-th percentile | 201.5701991 |
| Maximum | 430.2453697 |
| Range | 1043.002356 |
| Interquartile range (IQR) | 180.2751216 |
Descriptive statistics
| Standard deviation | 132.6811441 |
|---|---|
| Coefficient of variation (CV) | -5.394569572 |
| Kurtosis | 0.06477724278 |
| Mean | -24.59531615 |
| Median Absolute Deviation (MAD) | 88.36508133 |
| Skewness | 0.0398941903 |
| Sum | -73785.94844 |
| Variance | 17604.286 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -11.43497744 | 1 | < 0.1% |
| 81.68825244 | 1 | < 0.1% |
| 173.1163435 | 1 | < 0.1% |
| -22.53821861 | 1 | < 0.1% |
| -126.8300931 | 1 | < 0.1% |
| -65.57198075 | 1 | < 0.1% |
| 98.21262757 | 1 | < 0.1% |
| 187.3589182 | 1 | < 0.1% |
| 37.22691613 | 1 | < 0.1% |
| -35.41237661 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -612.7569858 | 1 | |
| -476.2814278 | 1 | |
| -454.5053215 | 1 | |
| -435.7985103 | 1 | |
| -421.6523874 | 1 | |
| -413.0620441 | 1 | |
| -408.3956705 | 1 | |
| -408.3150241 | 1 | |
| -402.6986362 | 1 | |
| -400.7874511 | 1 |
| Value | Count | Frequency (%) |
| 430.2453697 | 1 | |
| 404.3331059 | 1 | |
| 386.3581439 | 1 | |
| 374.4273003 | 1 | |
| 370.09821 | 1 | |
| 359.0160409 | 1 | |
| 353.8549631 | 1 | |
| 338.6824185 | 1 | |
| 328.8711654 | 1 | |
| 326.5902144 | 1 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.080555762 |
| Minimum | -503.6016615 |
|---|---|
| Maximum | 359.0697497 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1507 |
| Negative (%) | 50.2% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -503.6016615 |
|---|---|
| 5-th percentile | -197.618675 |
| Q1 | -82.92184947 |
| median | -0.7599613893 |
| Q3 | 81.00505497 |
| 95-th percentile | 172.3328408 |
| Maximum | 359.0697497 |
| Range | 862.6714112 |
| Interquartile range (IQR) | 163.9269044 |
Descriptive statistics
| Standard deviation | 118.0882764 |
|---|---|
| Coefficient of variation (CV) | -19.42063867 |
| Kurtosis | 0.1116788098 |
| Mean | -6.080555762 |
| Median Absolute Deviation (MAD) | 81.83937389 |
| Skewness | -0.2703709451 |
| Sum | -18241.66729 |
| Variance | 13944.84102 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -52.96174281 | 1 | < 0.1% |
| -40.29966289 | 1 | < 0.1% |
| 219.7067677 | 1 | < 0.1% |
| 152.6550353 | 1 | < 0.1% |
| 30.443556 | 1 | < 0.1% |
| -93.91141504 | 1 | < 0.1% |
| 4.822783223 | 1 | < 0.1% |
| -21.33632583 | 1 | < 0.1% |
| -204.305919 | 1 | < 0.1% |
| 194.6070706 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -503.6016615 | 1 | |
| -442.8515619 | 1 | |
| -433.4256362 | 1 | |
| -419.5340046 | 1 | |
| -417.9879362 | 1 | |
| -415.1243409 | 1 | |
| -402.4535788 | 1 | |
| -401.6756324 | 1 | |
| -387.5898681 | 1 | |
| -380.5710597 | 1 |
| Value | Count | Frequency (%) |
| 359.0697497 | 1 | |
| 319.9872759 | 1 | |
| 310.5408121 | 1 | |
| 306.9731401 | 1 | |
| 302.6539861 | 1 | |
| 299.9247381 | 1 | |
| 295.4645358 | 1 | |
| 295.3900838 | 1 | |
| 294.4903049 | 1 | |
| 292.7049592 | 1 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.05485006 |
| Minimum | -400.7216994 |
|---|---|
| Maximum | 465.9461662 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1506 |
| Negative (%) | 50.2% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -400.7216994 |
|---|---|
| 5-th percentile | -178.6902501 |
| Q1 | -77.78906076 |
| median | -0.8617628204 |
| Q3 | 90.39878539 |
| 95-th percentile | 216.1466573 |
| Maximum | 465.9461662 |
| Range | 866.6678656 |
| Interquartile range (IQR) | 168.1878461 |
Descriptive statistics
| Standard deviation | 122.2482028 |
|---|---|
| Coefficient of variation (CV) | 17.3282496 |
| Kurtosis | 0.04168426148 |
| Mean | 7.05485006 |
| Median Absolute Deviation (MAD) | 82.68260396 |
| Skewness | 0.2293033241 |
| Sum | 21164.55018 |
| Variance | 14944.62308 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -72.69638489 | 1 | < 0.1% |
| -53.73322694 | 1 | < 0.1% |
| -64.03244802 | 1 | < 0.1% |
| 140.5182936 | 1 | < 0.1% |
| -128.4835073 | 1 | < 0.1% |
| 15.22037242 | 1 | < 0.1% |
| 46.44866026 | 1 | < 0.1% |
| -92.42049848 | 1 | < 0.1% |
| 317.7885056 | 1 | < 0.1% |
| 251.4787916 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -400.7216994 | 1 | |
| -393.1232776 | 1 | |
| -371.7743888 | 1 | |
| -365.2271216 | 1 | |
| -342.3926102 | 1 | |
| -328.8292729 | 1 | |
| -313.9999961 | 1 | |
| -310.4092378 | 1 | |
| -308.1640677 | 1 | |
| -302.9326441 | 1 |
| Value | Count | Frequency (%) |
| 465.9461662 | 1 | |
| 423.4654061 | 1 | |
| 420.2422119 | 1 | |
| 417.4307891 | 1 | |
| 416.7362707 | 1 | |
| 394.9787606 | 1 | |
| 385.2716044 | 1 | |
| 381.0681929 | 1 | |
| 380.5657409 | 1 | |
| 359.1741369 | 1 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.2364888196 |
| Minimum | -340.0022366 |
|---|---|
| Maximum | 322.2359304 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1530 |
| Negative (%) | 51.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -340.0022366 |
|---|---|
| 5-th percentile | -161.8564647 |
| Q1 | -68.913955 |
| median | -2.206641342 |
| Q3 | 67.97689689 |
| 95-th percentile | 166.9794956 |
| Maximum | 322.2359304 |
| Range | 662.2381671 |
| Interquartile range (IQR) | 136.8908519 |
Descriptive statistics
| Standard deviation | 100.0832637 |
|---|---|
| Coefficient of variation (CV) | -423.2050542 |
| Kurtosis | -0.08154393495 |
| Mean | -0.2364888196 |
| Median Absolute Deviation (MAD) | 68.30203647 |
| Skewness | 0.01989113243 |
| Sum | -709.4664588 |
| Variance | 10016.65967 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 145.2992272 | 1 | < 0.1% |
| -162.1397146 | 1 | < 0.1% |
| 73.00119246 | 1 | < 0.1% |
| 36.00419316 | 1 | < 0.1% |
| -71.96920652 | 1 | < 0.1% |
| -38.50079605 | 1 | < 0.1% |
| -14.37967621 | 1 | < 0.1% |
| -46.99882002 | 1 | < 0.1% |
| -60.71093228 | 1 | < 0.1% |
| 105.4409747 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -340.0022366 | 1 | |
| -329.8845538 | 1 | |
| -313.4405423 | 1 | |
| -301.2956836 | 1 | |
| -294.6320985 | 1 | |
| -286.3028282 | 1 | |
| -285.3472334 | 1 | |
| -282.0931893 | 1 | |
| -274.0542497 | 1 | |
| -267.51496 | 1 |
| Value | Count | Frequency (%) |
| 322.2359304 | 1 | |
| 315.1707951 | 1 | |
| 311.4295421 | 1 | |
| 306.8682104 | 1 | |
| 292.3153243 | 1 | |
| 274.5369034 | 1 | |
| 273.1885257 | 1 | |
| 271.1978491 | 1 | |
| 269.3783122 | 1 | |
| 265.2004579 | 1 |
| Distinct | 3000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.04004858 |
| Minimum | -340.9956572 |
|---|---|
| Maximum | 370.8076238 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1455 |
| Negative (%) | 48.5% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | -340.9956572 |
|---|---|
| 5-th percentile | -165.3727289 |
| Q1 | -67.20441132 |
| median | 3.432020443 |
| Q3 | 69.03391447 |
| 95-th percentile | 164.1481965 |
| Maximum | 370.8076238 |
| Range | 711.8032809 |
| Interquartile range (IQR) | 136.2383258 |
Descriptive statistics
| Standard deviation | 100.899952 |
|---|---|
| Coefficient of variation (CV) | 97.01465292 |
| Kurtosis | -0.004668333845 |
| Mean | 1.04004858 |
| Median Absolute Deviation (MAD) | 67.47499578 |
| Skewness | 0.01031447578 |
| Sum | 3120.145741 |
| Variance | 10180.80032 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -143.8562427 | 1 | < 0.1% |
| -208.320213 | 1 | < 0.1% |
| 121.0260709 | 1 | < 0.1% |
| -88.68485341 | 1 | < 0.1% |
| -4.873041642 | 1 | < 0.1% |
| -20.88670655 | 1 | < 0.1% |
| -246.9250653 | 1 | < 0.1% |
| -96.20231682 | 1 | < 0.1% |
| 108.9904687 | 1 | < 0.1% |
| 8.426177077 | 1 | < 0.1% |
| Other values (2990) | 2990 |
| Value | Count | Frequency (%) |
| -340.9956572 | 1 | |
| -306.3574076 | 1 | |
| -294.353181 | 1 | |
| -286.4627158 | 1 | |
| -281.5434674 | 1 | |
| -279.751587 | 1 | |
| -273.4997926 | 1 | |
| -272.1359165 | 1 | |
| -265.8766558 | 1 | |
| -262.9471353 | 1 |
| Value | Count | Frequency (%) |
| 370.8076238 | 1 | |
| 334.4875459 | 1 | |
| 333.0379699 | 1 | |
| 320.8894336 | 1 | |
| 311.2954349 | 1 | |
| 304.3036752 | 1 | |
| 304.2546647 | 1 | |
| 294.1416357 | 1 | |
| 289.4396842 | 1 | |
| 288.9985204 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | Hour | Minutes | Sensor_alpha | Sensor_beta | Sensor_gamma | Sensor_alpha_plus | Sensor_beta_plus | Sensor_gamma_plus | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 7000 | 21 | 31 | -72.083585 | -11.434977 | -52.961743 | -72.696385 | 145.299227 | -143.856243 |
| 1 | 7001 | 21 | 3 | -193.619980 | 40.137081 | 85.419244 | -26.266801 | -125.391237 | 80.904973 |
| 2 | 7002 | 22 | 31 | 42.578382 | -51.613402 | 125.055611 | 182.136746 | -9.726951 | -114.913402 |
| 3 | 7003 | 21 | 25 | -64.150951 | 287.306752 | -70.965473 | 13.789738 | 38.187260 | 137.761691 |
| 4 | 7004 | 18 | 11 | 193.750787 | -61.989533 | -110.347066 | -16.864786 | 148.541916 | 232.424616 |
| 5 | 7005 | 21 | 5 | 200.151155 | -69.828082 | -103.909275 | 58.307127 | 6.339606 | -58.217237 |
| 6 | 7006 | 18 | 41 | -172.176846 | 27.400690 | -142.223978 | -190.350320 | -79.866788 | 104.104437 |
| 7 | 7007 | 21 | 39 | 164.427444 | -27.266671 | 41.961835 | -19.597537 | -40.367741 | 205.792899 |
| 8 | 7008 | 22 | 33 | 49.137676 | -219.450252 | -122.874167 | 178.923309 | -51.770902 | -113.031012 |
| 9 | 7009 | 18 | 28 | -21.098065 | -156.637421 | 7.043202 | 8.242528 | -29.718880 | 58.156633 |
Last rows
| df_index | Hour | Minutes | Sensor_alpha | Sensor_beta | Sensor_gamma | Sensor_alpha_plus | Sensor_beta_plus | Sensor_gamma_plus | |
|---|---|---|---|---|---|---|---|---|---|
| 2990 | 9990 | 21 | 12 | 17.677190 | 88.932349 | 106.609691 | -63.680847 | 11.901239 | -62.050918 |
| 2991 | 9991 | 19 | 30 | -31.941731 | -90.184404 | 121.333344 | 150.899550 | 51.252914 | 107.765113 |
| 2992 | 9992 | 19 | 3 | 82.172242 | -141.069527 | -41.133716 | 188.303696 | -153.310294 | 60.661858 |
| 2993 | 9993 | 11 | 34 | 237.639186 | -297.274989 | -172.872315 | 216.866617 | -170.684348 | 229.076958 |
| 2994 | 9994 | 19 | 58 | 110.544114 | 8.203070 | -155.356768 | -8.573200 | -154.493904 | -156.344969 |
| 2995 | 9995 | 3 | 26 | -101.913083 | 87.337077 | 77.193476 | -79.694034 | 13.273965 | 143.004786 |
| 2996 | 9996 | 21 | 6 | 52.424913 | -37.107249 | 120.373905 | 208.090551 | -135.567057 | -53.867634 |
| 2997 | 9997 | 21 | 0 | -103.295133 | 34.736979 | -195.018118 | -164.294768 | -26.993064 | 6.063715 |
| 2998 | 9998 | 20 | 13 | 170.027159 | -73.100306 | -117.330651 | 11.353824 | -3.366007 | -140.113661 |
| 2999 | 9999 | 19 | 17 | -173.839238 | 66.386097 | -141.968498 | 197.558808 | -44.847981 | 142.537872 |